Pandas Profiling Report

Dataset statistics

Number of variables	13
Number of observations	4335
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	440.4 KiB
Average record size in memory	104.0 B

Variable types

Numeric	13

Alerts

`monetary_purchase` is highly correlated with `quant_invoices` and 5 other fields	High correlation
`monetary_returns` is highly correlated with `quant_items` and 1 other fields	High correlation
`recency_days` is highly correlated with `avg_recency_day`	High correlation
`quant_invoices` is highly correlated with `monetary_purchase` and 3 other fields	High correlation
`quant_items` is highly correlated with `monetary_purchase` and 6 other fields	High correlation
`quant_prod_uniq` is highly correlated with `monetary_purchase` and 2 other fields	High correlation
`avg_ticket` is highly correlated with `monetary_purchase` and 4 other fields	High correlation
`avg_recency_day` is highly correlated with `recency_days` and 1 other fields	High correlation
`freq_purchases` is highly correlated with `quant_invoices` and 1 other fields	High correlation
`quant_returns` is highly correlated with `monetary_purchase` and 3 other fields	High correlation
`avg_basket_size` is highly correlated with `monetary_purchase` and 3 other fields	High correlation
`avg_uniq_basket_size` is highly correlated with `quant_prod_uniq` and 1 other fields	High correlation
`monetary_returns` is highly skewed (γ1 = -56.85806933)	Skewed
`avg_ticket` is highly skewed (γ1 = 59.5817417)	Skewed
`freq_purchases` is highly skewed (γ1 = 59.06192797)	Skewed
`quant_returns` is highly skewed (γ1 = 62.48337706)	Skewed
`avg_basket_size` is highly skewed (γ1 = 48.41859348)	Skewed
`customer_id` has unique values	Unique
`monetary_returns` has 2795 (64.5%) zeros	Zeros
`freq_purchases` has 1554 (35.8%) zeros	Zeros
`quant_returns` has 2795 (64.5%) zeros	Zeros

Reproduction

Analysis started	2022-12-19 15:33:27.306581
Analysis finished	2022-12-19 15:33:47.850768
Duration	20.54 seconds
Software version	pandas-profiling v3.4.0
Download configuration	config.json

customer_id
Real number (ℝ_≥0)

UNIQUE

Distinct	4335
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15301.11995

Minimum	12347
Maximum	18287
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	34.0 KiB

Quantile statistics

Minimum	12347
5-th percentile	12615.7
Q1	13813.5
median	15300
Q3	16779.5
95-th percentile	17984.3
Maximum	18287
Range	5940
Interquartile range (IQR)	2966

Descriptive statistics

Standard deviation	1721.77243
Coefficient of variation (CV)	0.1125259089
Kurtosis	-1.195948071
Mean	15301.11995
Median Absolute Deviation (MAD)	1484
Skewness	0.0009307401652
Sum	66330355
Variance	2964500.301
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17850	1	< 0.1%
17444	1	< 0.1%
15909	1	< 0.1%
13618	1	< 0.1%
16050	1	< 0.1%
17879	1	< 0.1%
17562	1	< 0.1%
15334	1	< 0.1%
12450	1	< 0.1%
13568	1	< 0.1%
Other values (4325)	4325	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
12347	1	< 0.1%
12348	1	< 0.1%
12349	1	< 0.1%
12350	1	< 0.1%
12352	1	< 0.1%
12353	1	< 0.1%
12354	1	< 0.1%
12355	1	< 0.1%
12356	1	< 0.1%
12357	1	< 0.1%

Value	Count	Frequency (%)
18287	1	< 0.1%
18283	1	< 0.1%
18282	1	< 0.1%
18281	1	< 0.1%
18280	1	< 0.1%
18278	1	< 0.1%
18277	1	< 0.1%
18276	1	< 0.1%
18274	1	< 0.1%
18273	1	< 0.1%

monetary_purchase
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	4248
Distinct (%)	98.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1951.137476

Minimum	3.75
Maximum	259657.3
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	34.0 KiB

Quantile statistics

Minimum	3.75
5-th percentile	112.164
Q1	305.685
median	668.04
Q3	1640.115
95-th percentile	5744.689
Maximum	259657.3
Range	259653.55
Interquartile range (IQR)	1334.43

Descriptive statistics

Standard deviation	7790.321213
Coefficient of variation (CV)	3.992707488
Kurtosis	469.1914378
Mean	1951.137476
Median Absolute Deviation (MAD)	463.8
Skewness	18.76917418
Sum	8458180.96
Variance	60689104.6
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
76.32	4	0.1%
35.4	3	0.1%
79.2	3	0.1%
440	3	0.1%
113.5	3	0.1%
363.65	3	0.1%
120	2	< 0.1%
324.24	2	< 0.1%
116.01	2	< 0.1%
110.38	2	< 0.1%
Other values (4238)	4308	99.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3.75	1	< 0.1%
6.2	1	< 0.1%
6.9	1	< 0.1%
12.75	1	< 0.1%
13.3	1	< 0.1%
15	2	< 0.1%
17	1	< 0.1%
20.8	2	< 0.1%
21.95	1	< 0.1%
25.5	2	< 0.1%

Value	Count	Frequency (%)
259657.3	1	< 0.1%
194550.79	1	< 0.1%
168472.5	1	< 0.1%
139638.06	1	< 0.1%
124564.53	1	< 0.1%
116725.63	1	< 0.1%
91062.38	1	< 0.1%
72882.09	1	< 0.1%
66653.56	1	< 0.1%
65019.62	1	< 0.1%

monetary_returns
Real number (ℝ)

HIGH CORRELATION
SKEWED
ZEROS

Distinct	1121
Distinct (%)	25.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-115.996203

Minimum	-168469.6
Maximum	0
Zeros	2795
Zeros (%)	64.5%
Negative	1540
Negative (%)	35.5%
Memory size	34.0 KiB

Quantile statistics

Minimum	-168469.6
5-th percentile	-175.201
Q1	-15.3
median	0
Q3	0
95-th percentile	0
Maximum	0
Range	168469.6
Interquartile range (IQR)	15.3

Descriptive statistics

Standard deviation	2702.109098
Coefficient of variation (CV)	-23.29480645
Kurtosis	3491.260968
Mean	-115.996203
Median Absolute Deviation (MAD)	0
Skewness	-56.85806933
Sum	-502843.54
Variance	7301393.578
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2795	64.5%
-12.75	21	0.5%
-4.95	18	0.4%
-9.95	17	0.4%
-15	16	0.4%
-5.9	12	0.3%
-25.5	11	0.3%
-4.25	10	0.2%
-3.75	8	0.2%
-19.9	8	0.2%
Other values (1111)	1419	32.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-168469.6	1	< 0.1%
-39267	1	< 0.1%
-22998.4	1	< 0.1%
-21889.48	1	< 0.1%
-12158.9	1	< 0.1%
-11202.44	1	< 0.1%
-8593.15	1	< 0.1%
-8495.01	1	< 0.1%
-6130.22	1	< 0.1%
-5759.64	1	< 0.1%

Value	Count	Frequency (%)
0	2795	64.5%
-0.42	2	< 0.1%
-0.65	1	< 0.1%
-0.77	1	< 0.1%
-0.95	1	< 0.1%
-1.25	4	0.1%
-1.45	4	0.1%
-1.64	1	< 0.1%
-1.65	5	0.1%
-1.7	2	< 0.1%

recency_days
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	304
Distinct (%)	7.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	92.05167243

Minimum	0
Maximum	373
Zeros	35
Zeros (%)	0.8%
Negative	0
Negative (%)	0.0%
Memory size	34.0 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	17
median	50
Q3	142
95-th percentile	311
Maximum	373
Range	373
Interquartile range (IQR)	125

Descriptive statistics

Standard deviation	99.93607143
Coefficient of variation (CV)	1.085651882
Kurtosis	0.4281095158
Mean	92.05167243
Median Absolute Deviation (MAD)	40
Skewness	1.24470537
Sum	399044
Variance	9987.218372
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	102	2.4%
4	94	2.2%
3	94	2.2%
2	89	2.1%
8	79	1.8%
10	77	1.8%
17	74	1.7%
7	72	1.7%
9	70	1.6%
22	64	1.5%
Other values (294)	3520	81.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	35	0.8%
1	102	2.4%
2	89	2.1%
3	94	2.2%
4	94	2.2%
5	48	1.1%
7	72	1.7%
8	79	1.8%
9	70	1.6%
10	77	1.8%

Value	Count	Frequency (%)
373	17	0.4%
372	17	0.4%
371	6	0.1%
369	3	0.1%
368	5	0.1%
367	5	0.1%
366	10	0.2%
365	10	0.2%
364	6	0.1%
362	6	0.1%

quant_invoices
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	57
Distinct (%)	1.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.242675894

Minimum	1
Maximum	209
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	34.0 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	2
Q3	5
95-th percentile	13
Maximum	209
Range	208
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	7.605354551
Coefficient of variation (CV)	1.792584383
Kurtosis	257.8028706
Mean	4.242675894
Median Absolute Deviation (MAD)	1
Skewness	12.25879931
Sum	18392
Variance	57.84141785
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1500	34.6%
2	833	19.2%
3	503	11.6%
4	394	9.1%
5	238	5.5%
6	172	4.0%
7	141	3.3%
8	98	2.3%
9	68	1.6%
11	54	1.2%
Other values (47)	334	7.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1500	34.6%
2	833	19.2%
3	503	11.6%
4	394	9.1%
5	238	5.5%
6	172	4.0%
7	141	3.3%
8	98	2.3%
9	68	1.6%
10	53	1.2%

Value	Count	Frequency (%)
209	1	< 0.1%
200	1	< 0.1%
124	1	< 0.1%
97	1	< 0.1%
91	2	< 0.1%
86	1	< 0.1%
62	2	< 0.1%
60	1	< 0.1%
57	1	< 0.1%
55	1	< 0.1%

quant_items
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	1757
Distinct (%)	40.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1126.843829

Minimum	1
Maximum	80997
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	34.0 KiB

Quantile statistics

Minimum	1
5-th percentile	46
Q1	160
median	378
Q3	988
95-th percentile	3535.5
Maximum	80997
Range	80996
Interquartile range (IQR)	828

Descriptive statistics

Standard deviation	3919.569049
Coefficient of variation (CV)	3.478360485
Kurtosis	213.9149559
Mean	1126.843829
Median Absolute Deviation (MAD)	275
Skewness	13.22510225
Sum	4884868
Variance	15363021.53
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
88	20	0.5%
120	17	0.4%
84	16	0.4%
144	16	0.4%
128	15	0.3%
146	15	0.3%
72	15	0.3%
106	14	0.3%
140	14	0.3%
150	14	0.3%
Other values (1747)	4179	96.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	5	0.1%
2	5	0.1%
3	4	0.1%
4	7	0.2%
5	3	0.1%
6	3	0.1%
7	1	< 0.1%
8	1	< 0.1%
9	2	< 0.1%
10	5	0.1%

Value	Count	Frequency (%)
80997	1	< 0.1%
79881	1	< 0.1%
77373	1	< 0.1%
69993	1	< 0.1%
64549	1	< 0.1%
64124	1	< 0.1%
62812	1	< 0.1%
58243	1	< 0.1%
57772	1	< 0.1%
50255	1	< 0.1%

quant_prod_uniq
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	463
Distinct (%)	10.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	91.00207612

Minimum	1
Maximum	7846
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	34.0 KiB

Quantile statistics

Minimum	1
5-th percentile	4
Q1	17
median	41
Q3	100
95-th percentile	314
Maximum	7846
Range	7845
Interquartile range (IQR)	83

Descriptive statistics

Standard deviation	226.1535221
Coefficient of variation (CV)	2.485146842
Kurtosis	499.4270294
Mean	91.00207612
Median Absolute Deviation (MAD)	30
Skewness	18.41531394
Sum	394494
Variance	51145.41555
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10	83	1.9%
6	76	1.8%
9	76	1.8%
1	73	1.7%
15	72	1.7%
11	70	1.6%
28	68	1.6%
8	67	1.5%
7	67	1.5%
5	67	1.5%
Other values (453)	3616	83.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	73	1.7%
2	52	1.2%
3	57	1.3%
4	49	1.1%
5	67	1.5%
6	76	1.8%
7	67	1.5%
8	67	1.5%
9	76	1.8%
10	83	1.9%

Value	Count	Frequency (%)
7846	1	< 0.1%
5588	1	< 0.1%
5095	1	< 0.1%
4591	1	< 0.1%
2698	1	< 0.1%
2379	1	< 0.1%
1818	1	< 0.1%
1676	1	< 0.1%
1636	1	< 0.1%
1502	1	< 0.1%

avg_ticket
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED

Distinct	4292
Distinct (%)	99.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	50.57841831

Minimum	2.101285714
Maximum	56157.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	34.0 KiB

Quantile statistics

Minimum	2.101285714
5-th percentile	4.525895261
Q1	12.29895425
median	17.58438596
Q3	24.67598759
95-th percentile	93.53833333
Maximum	56157.5
Range	56155.39871
Interquartile range (IQR)	12.37703334

Descriptive statistics

Standard deviation	885.3992073
Coefficient of variation (CV)	17.50547441
Kurtosis	3734.691061
Mean	50.57841831
Median Absolute Deviation (MAD)	6.234912281
Skewness	59.5817417
Sum	219257.4434
Variance	783931.7562
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
25.5	4	0.1%
15	4	0.1%
179	4	0.1%
76.32	4	0.1%
18.7	3	0.1%
24.4	2	< 0.1%
17	2	< 0.1%
207.5	2	< 0.1%
20.36	2	< 0.1%
19.375	2	< 0.1%
Other values (4282)	4306	99.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2.101285714	1	< 0.1%
2.150588235	1	< 0.1%
2.241	1	< 0.1%
2.264375	1	< 0.1%
2.4325	1	< 0.1%
2.462371134	1	< 0.1%
2.504876033	1	< 0.1%
2.50837156	1	< 0.1%
2.54704918	1	< 0.1%
2.563958333	1	< 0.1%

Value	Count	Frequency (%)
56157.5	1	< 0.1%
13305.5	1	< 0.1%
4453.43	1	< 0.1%
3861	1	< 0.1%
3096	1	< 0.1%
2033.1	1	< 0.1%
2027.86	1	< 0.1%
1687.2	1	< 0.1%
1377.077778	1	< 0.1%
1001.2	1	< 0.1%

avg_recency_day
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	1429
Distinct (%)	33.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	237.5766236

Minimum	5.687022901
Maximum	373
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	34.0 KiB

Quantile statistics

Minimum	5.687022901
5-th percentile	56.71678322
Q1	134.1
median	218.3333333
Q3	373
95-th percentile	373
Maximum	373
Range	367.3129771
Interquartile range (IQR)	238.9

Descriptive statistics

Standard deviation	118.1998573
Coefficient of variation (CV)	0.497523096
Kurtosis	-1.47991667
Mean	237.5766236
Median Absolute Deviation (MAD)	126.6190476
Skewness	-0.08400976914
Sum	1029894.663
Variance	13971.20626
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
373	1554	35.8%
187	15	0.3%
202	15	0.3%
199	13	0.3%
232	12	0.3%
197	12	0.3%
193.5	11	0.3%
192	10	0.2%
195	10	0.2%
204	10	0.2%
Other values (1419)	2673	61.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
5.687022901	1	< 0.1%
6.601769912	1	< 0.1%
6.651785714	1	< 0.1%
8.288888889	1	< 0.1%
8.370786517	1	< 0.1%
10.45070423	1	< 0.1%
11.21212121	1	< 0.1%
13.7037037	1	< 0.1%
14.03773585	1	< 0.1%
15.10416667	1	< 0.1%

Value	Count	Frequency (%)
373	1554	35.8%
369.5	1	< 0.1%
369	1	< 0.1%
368.5	1	< 0.1%
368	1	< 0.1%
365	2	< 0.1%
364.5	1	< 0.1%
364	2	< 0.1%
362.5	1	< 0.1%
362	2	< 0.1%

freq_purchases
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED
ZEROS

Distinct	1232
Distinct (%)	28.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.03975532161

Minimum	0
Maximum	34
Zeros	1554
Zeros (%)	35.8%
Negative	0
Negative (%)	0.0%
Memory size	34.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.01492537313
Q3	0.0303030303
95-th percentile	0.09030590263
Maximum	34
Range	34
Interquartile range (IQR)	0.0303030303

Descriptive statistics

Standard deviation	0.5364518284
Coefficient of variation (CV)	13.49383697
Kurtosis	3712.338665
Mean	0.03975532161
Median Absolute Deviation (MAD)	0.01492537313
Skewness	59.06192797
Sum	172.3393192
Variance	0.2877805642
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1554	35.8%
0.07142857143	15	0.3%
0.02857142857	14	0.3%
0.01587301587	14	0.3%
0.04761904762	14	0.3%
0.0303030303	13	0.3%
0.02380952381	13	0.3%
0.06451612903	13	0.3%
0.025	12	0.3%
0.03846153846	12	0.3%
Other values (1222)	2661	61.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1554	35.8%
0.005464480874	1	< 0.1%
0.005479452055	1	< 0.1%
0.005494505495	1	< 0.1%
0.005509641873	1	< 0.1%
0.005602240896	2	< 0.1%
0.005617977528	1	< 0.1%
0.005633802817	2	< 0.1%
0.005681818182	1	< 0.1%
0.005698005698	2	< 0.1%

Value	Count	Frequency (%)
34	1	< 0.1%
6	1	< 0.1%
4	1	< 0.1%
2	6	0.1%
1.5	1	< 0.1%
1.333333333	2	< 0.1%
1	5	0.1%
0.6666666667	3	0.1%
0.5603217158	1	< 0.1%
0.5376344086	1	< 0.1%

quant_returns
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED
ZEROS

Distinct	216
Distinct (%)	5.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	43.3893887

Minimum	0
Maximum	80995
Zeros	2795
Zeros (%)	64.5%
Negative	0
Negative (%)	0.0%
Memory size	34.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	4
95-th percentile	60
Maximum	80995
Range	80995
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	1252.611612
Coefficient of variation (CV)	28.86907719
Kurtosis	4028.482313
Mean	43.3893887
Median Absolute Deviation (MAD)	0
Skewness	62.48337706
Sum	188093
Variance	1569035.85
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2795	64.5%
1	186	4.3%
2	156	3.6%
3	107	2.5%
4	86	2.0%
6	76	1.8%
5	64	1.5%
12	50	1.2%
8	46	1.1%
7	46	1.1%
Other values (206)	723	16.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2795	64.5%
1	186	4.3%
2	156	3.6%
3	107	2.5%
4	86	2.0%
5	64	1.5%
6	76	1.8%
7	46	1.1%
8	46	1.1%
9	41	0.9%

Value	Count	Frequency (%)
80995	1	< 0.1%
9014	1	< 0.1%
8059	1	< 0.1%
4627	1	< 0.1%
3768	1	< 0.1%
3334	1	< 0.1%
2975	1	< 0.1%
2022	1	< 0.1%
2012	1	< 0.1%
1920	1	< 0.1%

avg_basket_size
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED

Distinct	2122
Distinct (%)	49.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	236.447602

Minimum	1
Maximum	40498.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	34.0 KiB

Quantile statistics

Minimum	1
5-th percentile	35
Q1	93
median	161.75
Q3	271
95-th percentile	597.2375
Maximum	40498.5
Range	40497.5
Interquartile range (IQR)	178

Descriptive statistics

Standard deviation	681.4721968
Coefficient of variation (CV)	2.882127757
Kurtosis	2818.432136
Mean	236.447602
Median Absolute Deviation (MAD)	81.25
Skewness	48.41859348
Sum	1025000.355
Variance	464404.355
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	19	0.4%
82	18	0.4%
88	18	0.4%
120	18	0.4%
73	17	0.4%
144	16	0.4%
72	16	0.4%
60	16	0.4%
136	16	0.4%
106	16	0.4%
Other values (2112)	4165	96.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	6	0.1%
1.5	1	< 0.1%
2	4	0.1%
3	3	0.1%
3.333333333	1	< 0.1%
4	7	0.2%
5	3	0.1%
5.333333333	1	< 0.1%
5.666666667	1	< 0.1%
6	3	0.1%

Value	Count	Frequency (%)
40498.5	1	< 0.1%
7824	1	< 0.1%
6009.333333	1	< 0.1%
4300	1	< 0.1%
4282	1	< 0.1%
4280	1	< 0.1%
3868.65	1	< 0.1%
3028	1	< 0.1%
2924	1	< 0.1%
2880	1	< 0.1%

avg_uniq_basket_size
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	933
Distinct (%)	21.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	18.73424121

Minimum	0.2
Maximum	219
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	34.0 KiB

Quantile statistics

Minimum	0.2
5-th percentile	2
Q1	8
median	14
Q3	24
95-th percentile	52
Maximum	219
Range	218.8
Interquartile range (IQR)	16

Descriptive statistics

Standard deviation	17.22847967
Coefficient of variation (CV)	0.9196251655
Kurtosis	14.94353183
Mean	18.73424121
Median Absolute Deviation (MAD)	7.4
Skewness	2.817387236
Sum	81212.93565
Variance	296.8205118
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	95	2.2%
9	90	2.1%
8	89	2.1%
10	88	2.0%
13	86	2.0%
7	85	2.0%
6	81	1.9%
11	78	1.8%
14	75	1.7%
5	75	1.7%
Other values (923)	3493	80.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.2	1	< 0.1%
0.25	3	0.1%
0.3333333333	7	0.2%
0.4	1	< 0.1%
0.4090909091	1	< 0.1%
0.5	12	0.3%
0.5454545455	1	< 0.1%
0.5714285714	1	< 0.1%
0.6	1	< 0.1%
0.6176470588	1	< 0.1%

Value	Count	Frequency (%)
219	1	< 0.1%
177	1	< 0.1%
171	1	< 0.1%
155	1	< 0.1%
154	1	< 0.1%
148	2	< 0.1%
141	1	< 0.1%
131	1	< 0.1%
128	1	< 0.1%
127	1	< 0.1%

Auto

The auto setting is an easily interpretable pairwise column metric of the following mapping: vartype-vartype : method, categorical-categorical : Cramer's V, numerical-categorical : Cramer's V (using a discretized numerical column), numerical-numerical : Spearman's ρ. This configuration uses the best suitable for each pair of columns.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	customer_id	monetary_purchase	monetary_returns	recency_days	quant_invoices	quant_items	quant_prod_uniq	avg_ticket	avg_recency_day	freq_purchases	quant_returns	avg_basket_size	avg_uniq_basket_size
0	17850	5391.21	-102.58	372.0	34.0	1733.0	297.0	18.152222	187.000000	34.000000	40.0	50.970588	0.617647
1	13047	3237.54	-158.44	31.0	10.0	1391.0	172.0	18.822907	89.375000	0.029240	36.0	139.100000	10.600000
2	12583	6705.38	-76.04	2.0	15.0	5028.0	232.0	28.902500	49.600000	0.040431	50.0	335.200000	7.600000
3	13748	948.25	0.00	95.0	5.0	439.0	28.0	33.866071	162.750000	0.017986	0.0	87.800000	4.800000
4	15100	876.00	-240.90	333.0	3.0	80.0	3.0	292.000000	137.666667	0.075000	22.0	26.666667	0.333333
5	15291	4668.30	-71.79	25.0	15.0	2103.0	103.0	45.323301	48.066667	0.043103	29.0	140.200000	4.133333
6	14688	5630.87	-523.49	7.0	21.0	3621.0	327.0	17.219786	36.950000	0.057377	399.0	172.428571	7.047619
7	17809	5411.91	-784.29	16.0	12.0	2057.0	61.0	88.719836	73.000000	0.033613	42.0	171.416667	3.833333
8	15311	60767.90	-1348.56	0.0	91.0	38194.0	2379.0	25.543464	8.288889	0.243968	474.0	419.714286	6.230769
9	14527	8508.82	-797.44	2.0	55.0	2089.0	972.0	8.753930	13.703704	0.149864	40.0	37.981818	6.000000

Last rows

	customer_id	monetary_purchase	monetary_returns	recency_days	quant_invoices	quant_items	quant_prod_uniq	avg_ticket	avg_recency_day	quant_returns	avg_basket_size	avg_uniq_basket_size
4325	16000	12393.70	0.00	2.0	3.0	5110.0	9.0	1377.077778	373.0	0.0	1703.333333	3.0
4326	15195	3861.00	0.00	2.0	1.0	1404.0	1.0	3861.000000	373.0	0.0	1404.000000	1.0
4327	14087	194.42	-12.75	2.0	1.0	251.0	69.0	2.817681	373.0	1.0	251.000000	61.0
4328	14204	161.03	0.00	2.0	1.0	82.0	44.0	3.659773	373.0	0.0	82.000000	36.0
4329	15471	469.48	0.00	2.0	1.0	266.0	77.0	6.097143	373.0	0.0	266.000000	67.0
4330	13436	196.89	0.00	1.0	1.0	76.0	12.0	16.407500	373.0	0.0	76.000000	12.0
4331	15520	343.50	0.00	1.0	1.0	314.0	18.0	19.083333	373.0	0.0	314.000000	18.0
4332	13298	360.00	0.00	1.0	1.0	96.0	2.0	180.000000	373.0	0.0	96.000000	2.0
4333	14569	227.39	0.00	1.0	1.0	79.0	12.0	18.949167	373.0	0.0	79.000000	10.0
4334	12713	794.55	0.00	0.0	1.0	505.0	37.0	21.474324	373.0	0.0	505.000000	37.0

Overview

Variables

Interactions

Correlations

Auto

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows